-- @owner: @kyeleze
-- @date: 2022/6/9
-- @testpoint: 建表语句

--step1:建表 expect:建表成功
drop table if exists t_ustore_ceil_0016_01;
create table t_ustore_ceil_0016_01(
col_1 decimal,
col_2 int ,
col_3 float8,
col_4 decimal(6,2)
) with (storage_type=ustore);

--step2:创建序列 expect:序列创建成功
drop sequence if exists s_ceil_seq;
create sequence s_ceil_seq increment by 1 start with 100000;

--step3:循环插入1000条数据 expect:插入成功
begin
 for i in 1..1000 loop
      insert into t_ustore_ceil_0016_01 values(
   3.1415926+s_ceil_seq.nextval,
   i,
   1.0e+100,
   i+445.255
   );
    end loop;
end;
/

--step4:暂不清理环境 expect:后续用例使用，case0036用例清理环境